Range Buckets Registry entry

Define range buckets for a field (i.e. when fine-tuning Range Indexing).

Description

The setting of range bucket values is performed on a per field basis. Each range indexed field may have a Registry entry that defines the range buckets for that field. If a Registry entry does not exist, the built-in values defined when the table was designed are used. Using the Range Buckets Registry entry, System Administrators can set the range buckets on any range based field manually.

Usage

This Registry entry is assigned at the system level only:

Key System
Key 1 System
Key 2 Setting
Key 3 Table
Key 4 table
Key 5 Range Buckets
Key 6 column
Value bucket;bucket;...

where:

table

is the name of the EMu module that contains the field to be configured.

column

is the name of the field (this can be determined by using the What's this help? facility in the EMu client, or via the emuindexing command).

bucket;bucket;...

is a semicolon separated list of values to be used for range buckets. The format of the value depends on the field type.

It is important to make sure that the values specified are all fully qualified. In particular, full date values are required. The table below shows what constitutes a fully qualified value for each field type:

Field Type

Format

Examples

Integer N -10, 12, 25
Float n.nnnn -23.0, -5, 2.125, 10
Date yyyy-mm-dd 2003-10-23, 2008-03-17
Time hh:mm:ss.sss 10:30:00, 18:00:00.000
Latitude dd:mm:ss.sss:D 9:12:15.1:N, 35:06:01:S
Longitude ddd:mm:ss.sss:D 123:34:06.34:W

Examples

In this example the Date Visited field has range buckets of 2000-01-01, 2003-01-01, 2006-01-01 and 2009-01-01. This entry may be used to set these buckets:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Table
Key 4 ecollectionevents
Key 5 Range Buckets
Key 6 ColDateVisited
Value 2000-01-01;2003-01-02;2006-01-01;2009-01-01

This Registry entry could be used to set the range buckets on the Latitude field in the Collection Events module:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Table
Key 4 ecollectionevents
Key 5 Range Buckets
Key 6 LatLatitude_tab
Value 16:00:00:S;18:00:00:S;20:00:00:S;22:00:00:S

Related Topics Link IconRelated Topics